package cn.com.api.mapper.base;

import java.util.List;
import org.apache.ibatis.annotations.*;
import cn.com.api.entity.U_article_resource;

public interface U_article_resourceMapperBase {

	// 根据id查看
	@Select("SELECT * FROM u_article_resource  WHERE id = #{id}")
	public U_article_resource findU_article_resourceById(Integer id);

	// 查看数据集
	@Select("SELECT * FROM u_article_resource")
	public List<U_article_resource> findU_article_resource();

	// 添加
	public int insertU_article_resource(U_article_resource u_article_resource);

	// 修改
	@Update("UPDATE u_article_resource SET article_id = #{article_id}, img = #{img}, description = #{description}, sort = #{sort} WHERE id = #{id}")
	public int updateU_article_resource(U_article_resource u_article_resource);

	// 删除
	@Delete("DELETE FROM u_article_resource  WHERE id = #{id}")
	public int deleteU_article_resource(Integer id);

	// Foreign keys revelant

	// region Indexs revelant
}
